<?php
include_once("../modules/checkA.php");
include_once("../../config.php"); 
$plate=select_one_line_all_items($table_Prefix."plate","mid = 'inventory'");
?>


<?
//用来判断当前系统属于什么板块
$system_part = $plate['mid']; 
?>
 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<?php include_once(ROOT_PATH_.'/controlbase/modules/head.php'); ?>
</head>

<body>

 
 

<?php
//接收需要修改的数据的id
$new_detail_nid = addslashes($_REQUEST['nid']);

//传递过来的页面信息。返回的时候，会根据这些信息返回原来的页面
$nowpageid      = addslashes($_REQUEST['nowpageid']);
$sortby         = addslashes($_REQUEST['sortby']);
$term_nid       = addslashes($_REQUEST['term_nid']);



$new_detail_number        = addslashes($_REQUEST['number']);
$new_detail_people        = addslashes($_REQUEST['people']);
$new_detail_remark        = addslashes($_REQUEST['remark']);
$new_detail_applydate     = addslashes($_REQUEST['applydate']);
$new_detail_materialnid   = addslashes($_REQUEST['materialnid']);
$new_detail_departmentnid = addslashes($_REQUEST['department']);
$new_detail_price         = addslashes($_REQUEST['price']);






//先检查一下库存状态
$material_sum=sum_total($table_Prefix."inventory","number"," materialnid = '".$new_detail_materialnid."'");



if (abs($new_detail_number)>$material_sum)
{
    ?>
    <script type="text/javascript">
        alert("超出库存，请重新领取.");
         history.back();
    </script>

    <?

}

else{









//设置需要搜索的表格的前缀后缀
$table_Suffix = $plate['table_Suffix'];
$table        = $table_Prefix . $table_Suffix;
 

$sql = "update $table SET
number        = '$new_detail_number',
people        = '$new_detail_people',
remark        = '$new_detail_remark',
applydate     = '$new_detail_applydate',
materialnid   = '$new_detail_materialnid',
departmentnid = '$new_detail_department',
price         = '$new_detail_price'
where nid=$new_detail_nid";
$query = mysql_query($sql) or die ('更新detail表数据失败');


mysql_close($con);










//插入数据之后，还要判断一下，增减库存之后，物料的库存是否告急

//计算领取的平均数
$intentory_avg=abs(count_avg($table_Prefix."inventory","number"," materialnid = '".$new_detail_materialnid."' and number < 0"));

$material_sum=sum_total($table_Prefix."inventory","number"," materialnid = '".$new_detail_materialnid."'");



if($intentory_avg>$material_sum*2){
    $material_status        = "紧张";
}
else
{
    $material_status        = "充足";
}






//设置需要搜索的表格的前缀后缀
$table_Suffix = "material";
$table = $table_Prefix . $table_Suffix;
//设置需要搜索的表格的前缀后缀




$sql = "update $table SET
status= '$material_status'
where nid=$new_detail_materialnid";



//这里应该要根据数目加减来到和财务系统联动。

$query = mysql_query($sql) or die ('添加数据失败！！');


?>






<script type="text/javascript">

    alert("输入信息已保存，点击确认返回继续操作.");
    document.location.href = "detail-list.php?nowpageid=<? echo $nowpageid ?>&sortby=<? echo $sortby?>&nid=<? echo $term_nid ?>&sys_part=<? echo $system_part ?>&nav-itemed=material"

</script>


<?
}
?>

</body>